<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Host LUN Allocation Trending</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Host Count</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="Trending">
			<contents><textItem><dataSource><dataItemValue refDataItem="Host Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Thick Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="Current">
			<contents><textItem><dataSource><dataItemValue refDataItem="Thick Capacity TB"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Thin Capcity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton3" refQuery="Current">
			<contents><textItem><dataSource><dataItemValue refDataItem="Thin Capacity TB"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Thin Consumed</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="Current">
			<contents><textItem><dataSource><dataItemValue refDataItem="Thin Used TB"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Thin % Consumed</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton5" refQuery="Current">
			<contents><textItem><dataSource><dataItemValue refDataItem="Thin Used %"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><percentFormat/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Select Host: </staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:bold;color:#808080"/></style></textItem></contents></tableCell><tableCell><contents><selectValue parameter="sHost" multiSelect="false" range="false" required="false" refQuery="Host Prompt" autoSubmit="true"><useItem refDataItem="Host"/></selectValue></contents></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 5px 10px;height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>LUN Allocation Trending</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List2" refQuery="Trending">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Host"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents/><listColumnRowSpan refDataItem="Host"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Volume"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents/><listColumnRowSpan refDataItem="Volume"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Thin/Thick"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Thin/Thick"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Capacity GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Capacity GB"/></dataSource><style><dataFormat><numberFormat pattern="###,###.##' GB'"/></dataFormat></style></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Consumed GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Consumed GB"/></dataSource><style><dataFormat><numberFormat pattern="###,###.##' GB'"/></dataFormat></style></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="% Used"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="% Used"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><staticValue>LUN Allocation History</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="padding-bottom:15px"/></style><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart2" refQuery="Trending">
													<v2_combinationTypeTooltips/>
													<v2_commonAxis>
														<v2_ordinalAxis>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																<CSS value="font-size:8pt"/></style>
															</v2_axisLabels>
														</v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat showYears="false" showMonths="1-digit" showDays="1-digit" dateSeparator="/"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
													<v2_topLeftAxis>
														<v2_combinationChartTypes>
															<v2_line lineDisplayType="lineAndMarkers" lineAreaShape="smooth">
																<v2_linePalette markerSize="5pt">
																	<v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette>
																
																<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Provisioned (GB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Consumed (GB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line>
														</v2_combinationChartTypes>
														<v2_axis>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																<CSS value="font-size:8pt"/><dataFormat><numberFormat pattern="###,###' GB'"/></dataFormat></style>
															</v2_axisLabels>
															<v2_axisRange scale="linear">
																<v2_automaticRange sameRangeAllInstances="false" includeZeroForAutoScale="true"/>
															</v2_axisRange></v2_axis>
													</v2_topLeftAxis>
													<style>
														<CSS value="width:450px;height:90px;border:1pt solid silver"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
													<noDataHandler>
														<contents>
															<block>
																<contents>
																	<textItem>
																		<dataSource>
																			<staticValue>No Data Available</staticValue>
																		</dataSource>
																		<style>
																			<CSS value="padding:10px 18px;"/>
																		</style>
																	</textItem>
																</contents>
															</block>
														</contents>
													</noDataHandler>
													<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Volume"/></masterContext><detailContext><dataItemContext refDataItem="Volume"/></detailContext></masterDetailLink><masterDetailLink><masterContext><dataItemContext refDataItem="Host"/></masterContext><detailContext><dataItemContext refDataItem="Host"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart>
											</contents></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="Host"><listHeader><listRows><listRow><rowCells><rowCell colSpan="9"><contents><textItem><dataSource><staticValue>Host Name: </staticValue></dataSource><style><CSS value="color:#333333"/></style></textItem><textItem><dataSource><dataItemValue refDataItem="Host"/></dataSource><style><CSS value="color:#333333"/></style></textItem><textItem><dataSource><staticValue>, </staticValue></dataSource><style><CSS value="color:#333333"/></style></textItem><textItem><dataSource><dataItemValue refDataItem="OS"/></dataSource><style><CSS value="color:#333333"/></style></textItem></contents><style><CSS value="background-color:white"/><defaultStyles><defaultStyle refStyle="oh"/></defaultStyles></style></rowCell></rowCells></listRow></listRows></listHeader></listGroup><listGroup refDataItem="Volume"><listHeader><listRows><listRow><rowCells><rowCell colSpan="8"><contents><textItem><dataSource><staticValue>Volume Name: </staticValue></dataSource><style><CSS value="color:#333333"/></style></textItem><textItem><dataSource><dataItemValue refDataItem="Volume"/></dataSource><style><CSS value="color:#0066FF"/></style></textItem></contents><style><CSS value="background-color:white;padding-bottom:10px"/><defaultStyles><defaultStyle refStyle="ih"/></defaultStyles></style></rowCell></rowCells></listRow></listRows></listHeader><sortList><sortItem refDataItem="Thin/Thick" sortOrder="descending"/></sortList></listGroup></listGroups></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px;padding-bottom:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							<pageSetup orientation="portrait"><customPaper width="11" height="11" unit="in"/></pageSetup></page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>7.4 Host LUN Allocation Trending</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="Trending"><source><sqlQuery name="SQL1" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.host_dimension.name as 'Host',
IF(dwh_capacity.host_dimension.os is null,  IF(dwh_capacity.volume_dimension.type LIKE CONCAT('%','OS:','%'), SUBSTR(dwh_capacity.volume_dimension.type,LOCATE(':',dwh_capacity.volume_dimension.type)+1,100), 'UnKnown'), 
dwh_capacity.host_dimension.os) as 'OS',

dwh_capacity.storage_dimension.name as 'Storage',
dwh_capacity.volume_dimension.name as 'Volume',
IF(dwh_capacity.volume_dimension.thinprovisioned=1,'Thin Provisioned','Thick Provisioned') as 'Thin/Thick',
dwh_capacity.business_entity_dimension.businessunit as 'Business Unit',
dwh_capacity.volume_history_capacity_fact.provisionedCapacityMB/1024 as 'Provisioned (GB)',
dwh_capacity.volume_history_capacity_fact.consumedCapacityMB/1024 as 'Consumed (GB)',


(SELECT dwh_inventory.volume.capacityMB/1024 FROM dwh_inventory.volume WHERE dwh_inventory.volume.id=dwh_capacity.volume_dimension.id) as 'Capacity GB',
(SELECT dwh_inventory.volume.consumedCapacityMB/1024 FROM dwh_inventory.volume WHERE dwh_inventory.volume.id=dwh_capacity.volume_dimension.id) as 'Consumed GB',

dwh_capacity.date_dimension.fulldate as 'Date'

FROM dwh_capacity.volume_history_capacity_fact
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.volume_history_capacity_fact.datetk
AND dwh_capacity.date_dimension.repmonthorlatest=1
JOIN dwh_capacity.host_dimension
ON dwh_capacity.host_dimension.tk=dwh_capacity.volume_history_capacity_fact.hosttk
AND dwh_capacity.host_dimension.name&lt;&gt;'N/A'
JOIN dwh_capacity.volume_dimension
ON dwh_capacity.volume_dimension.tk=dwh_capacity.volume_history_capacity_fact.volumetk
JOIN dwh_capacity.storage_dimension
ON dwh_capacity.storage_dimension.tk=dwh_capacity.volume_history_capacity_fact.storagetk
LEFT JOIN  dwh_capacity.chargeback_fact
ON dwh_capacity.chargeback_fact.tk=dwh_capacity.volume_history_capacity_fact.chargebackFactTk AND dwh_capacity.chargeback_fact.hosttk=dwh_capacity.host_dimension.tk
AND dwh_capacity.chargeback_fact.datetk=dwh_capacity.date_dimension.tk
LEFT JOIN dwh_capacity.business_entity_dimension
ON dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk

GROUP BY dwh_capacity.host_dimension.tk, dwh_capacity.business_entity_dimension.businessunit, dwh_capacity.storage_dimension.tk, dwh_capacity.volume_dimension.tk, dwh_capacity.date_dimension.tk
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Host"/><mdProjectedItem name="OS"/><mdProjectedItem name="Storage"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Thin/Thick"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Provisioned (GB)"/><mdProjectedItem name="Consumed (GB)"/><mdProjectedItem name="Capacity GB"/><mdProjectedItem name="Consumed GB"/><mdProjectedItem name="Date"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Host"><expression>[SQL1].[Host]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL1].[Business Unit]</expression></dataItem><dataItem name="OS"><expression>[SQL1].[OS]</expression></dataItem><dataItem name="Thin/Thick"><expression>[SQL1].[Thin/Thick]</expression></dataItem><dataItem name="Volume" label="OS"><expression>[SQL1].[Volume]</expression></dataItem><dataItem name="Storage"><expression>[SQL1].[Storage]</expression></dataItem><dataItem name="Provisioned (GB)" aggregate="total"><expression>[SQL1].[Provisioned (GB)]</expression></dataItem><dataItem name="Consumed (GB)" aggregate="total"><expression>[SQL1].[Consumed (GB)]</expression></dataItem><dataItem name="Date"><expression>[SQL1].[Date]</expression></dataItem><dataItem name="Capacity GB"><expression>[SQL1].[Capacity GB]</expression></dataItem><dataItem name="Consumed GB"><expression>[SQL1].[Consumed GB]</expression></dataItem><dataItem name="% Used"><expression>IF([Thin/Thick]='Thin Provisioned') THEN ([Consumed GB]/[Capacity GB]) ELSE (null)</expression></dataItem><dataItem name="Host Count" aggregate="total"><expression>count(distinct [Host])</expression></dataItem><dataItem name="Thick Capacity TB" aggregate="total"><expression>IF([Thin/Thick] contains 'Thick') THEN ([Provisioned (GB)]/1024) ELSE (0)</expression></dataItem><dataItem name="Thin Capacity TB" aggregate="total"><expression>IF([Thin/Thick] contains 'Thin') THEN ([Provisioned (GB)]/1024) ELSE (0)</expression></dataItem><dataItem name="Max Date"><expression>maximum([Date] for report)</expression></dataItem><dataItem name="Thin Used %"><expression>[Thin Used TB]/[Thin Capacity TB]</expression></dataItem><dataItem name="Thin Used TB" aggregate="total"><expression>IF([Thin/Thick] contains 'Thin') THEN ([Consumed (GB)]/1024) ELSE (0)</expression></dataItem></selection><detailFilters><detailFilter><filterExpression>[Capacity GB] is not null</filterExpression></detailFilter><detailFilter use="optional"><filterExpression>[Host]=?sHost?</filterExpression></detailFilter></detailFilters></query><query name="Current">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.host_dimension.name as 'Host',
IF(dwh_capacity.host_dimension.os is null,  IF(dwh_capacity.volume_dimension.type LIKE CONCAT('%','OS:','%'), SUBSTR(dwh_capacity.volume_dimension.type,LOCATE(':',dwh_capacity.volume_dimension.type)+1,100), 'UnKnown'), 
dwh_capacity.host_dimension.os) as 'OS',

dwh_capacity.storage_dimension.name as 'Storage',
dwh_capacity.volume_dimension.name as 'Volume',
IF(dwh_capacity.volume_dimension.thinprovisioned=1,'Thin Provisioned','Thick Provisioned') as 'Thin/Thick',
dwh_capacity.business_entity_dimension.businessunit as 'Business Unit',
dwh_capacity.volume_history_capacity_fact.provisionedCapacityMB/1024 as 'Provisioned (GB)',
dwh_capacity.volume_history_capacity_fact.consumedCapacityMB/1024 as 'Consumed (GB)',


(SELECT dwh_inventory.volume.capacityMB/1024 FROM dwh_inventory.volume WHERE dwh_inventory.volume.id=dwh_capacity.volume_dimension.id) as 'Capacity GB',
(SELECT dwh_inventory.volume.consumedCapacityMB/1024 FROM dwh_inventory.volume WHERE dwh_inventory.volume.id=dwh_capacity.volume_dimension.id) as 'Consumed GB',

dwh_capacity.date_dimension.fulldate as 'Date'

FROM dwh_capacity.volume_history_capacity_fact
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.volume_history_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
JOIN dwh_capacity.host_dimension
ON dwh_capacity.host_dimension.tk=dwh_capacity.volume_history_capacity_fact.hosttk
AND dwh_capacity.host_dimension.name&lt;&gt;'N/A'
JOIN dwh_capacity.volume_dimension
ON dwh_capacity.volume_dimension.tk=dwh_capacity.volume_history_capacity_fact.volumetk
JOIN dwh_capacity.storage_dimension
ON dwh_capacity.storage_dimension.tk=dwh_capacity.volume_history_capacity_fact.storagetk
LEFT JOIN  dwh_capacity.chargeback_fact
ON dwh_capacity.chargeback_fact.tk=dwh_capacity.volume_history_capacity_fact.chargebackFactTk AND dwh_capacity.chargeback_fact.hosttk=dwh_capacity.host_dimension.tk
AND dwh_capacity.chargeback_fact.datetk=dwh_capacity.date_dimension.tk
LEFT JOIN dwh_capacity.business_entity_dimension
ON dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk

GROUP BY dwh_capacity.host_dimension.tk, dwh_capacity.business_entity_dimension.businessunit, dwh_capacity.storage_dimension.tk, dwh_capacity.volume_dimension.tk
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Host"/><mdProjectedItem name="OS"/><mdProjectedItem name="Storage"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Thin/Thick"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Provisioned (GB)"/><mdProjectedItem name="Consumed (GB)"/><mdProjectedItem name="Capacity GB"/><mdProjectedItem name="Consumed GB"/><mdProjectedItem name="Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Host"><expression>[SQL2].[Host]</expression></dataItem><dataItem name="OS"><expression>[SQL2].[OS]</expression></dataItem><dataItem name="Storage"><expression>[SQL2].[Storage]</expression></dataItem><dataItem name="Volume"><expression>[SQL2].[Volume]</expression></dataItem><dataItem name="Thin/Thick"><expression>[SQL2].[Thin/Thick]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL2].[Business Unit]</expression></dataItem><dataItem name="Provisioned (TB)" aggregate="total"><expression>[SQL2].[Provisioned (GB)]/1024
</expression></dataItem><dataItem name="Consumed (TB)" aggregate="total"><expression>[SQL2].[Consumed (GB)]/1024</expression></dataItem><dataItem name="Capacity GB" aggregate="total"><expression>[SQL2].[Capacity GB]</expression></dataItem><dataItem name="Consumed GB" aggregate="total"><expression>[SQL2].[Consumed GB]</expression></dataItem><dataItem name="Date"><expression>[SQL2].[Date]</expression></dataItem><dataItem name="Thick Capacity TB" aggregate="total"><expression>IF([Thin/Thick] contains 'Thick') THEN ([Provisioned (TB)]) ELSE (0)</expression></dataItem><dataItem name="Thin Capacity TB" aggregate="total"><expression>IF([Thin/Thick] contains 'Thin') THEN ([Provisioned (TB)]) ELSE (0)</expression></dataItem><dataItem name="Thin Used %"><expression>[Thin Used TB]/[Thin Capacity TB]</expression></dataItem><dataItem name="Thin Used TB" aggregate="total"><expression>IF([Thin/Thick] contains 'Thin') THEN ([Consumed (TB)]) ELSE (0)</expression></dataItem><dataItem name="Host Count" aggregate="total"><expression>count(distinct [Host])</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Host]=?sHost?</filterExpression></detailFilter></detailFilters></query><query name="Host Prompt">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.host_dimension.name as 'Host'

FROM dwh_capacity.volume_history_capacity_fact
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.volume_history_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1
JOIN dwh_capacity.host_dimension
ON dwh_capacity.host_dimension.tk=dwh_capacity.volume_history_capacity_fact.hosttk
AND dwh_capacity.host_dimension.name&lt;&gt;'N/A'
JOIN dwh_capacity.volume_dimension
ON dwh_capacity.volume_dimension.tk=dwh_capacity.volume_history_capacity_fact.volumetk
JOIN dwh_capacity.storage_dimension
ON dwh_capacity.storage_dimension.tk=dwh_capacity.volume_history_capacity_fact.storagetk
LEFT JOIN  dwh_capacity.chargeback_fact
ON dwh_capacity.chargeback_fact.tk=dwh_capacity.volume_history_capacity_fact.chargebackFactTk AND dwh_capacity.chargeback_fact.hosttk=dwh_capacity.host_dimension.tk
AND dwh_capacity.chargeback_fact.datetk=dwh_capacity.date_dimension.tk
LEFT JOIN dwh_capacity.business_entity_dimension
ON dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk

GROUP BY dwh_capacity.host_dimension.tk, dwh_capacity.business_entity_dimension.businessunit, dwh_capacity.storage_dimension.tk, dwh_capacity.volume_dimension.tk
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Host"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Host"><expression>[SQL3].[Host]</expression></dataItem></selection>
		</query></queries></report>